/**
 * Created by chengke on 2018/2/28.
 */

let Sequelize = require('sequelize');

let sequelize = require('./db.js').webAccount;

module.exports = sequelize.define('keyword', {
    id: {
        comment: '主键',
        primaryKey: true,
        type: Sequelize.INTEGER
    },
    keywordId: {
        type: Sequelize.STRING,
        field: 'keyword_id'
    },
    adgroupId: {
        type: Sequelize.STRING,
        field: 'adgroup_id'
    },
    campaignId: {
        type: Sequelize.STRING,
        field: 'campaign_id'
    },
    keyword: {
        type: Sequelize.STRING,
        field: 'keyword'
    },
    price: {
        type: Sequelize.STRING,
        field: 'price'
    },
    pcDestinationUrl: {
        type: Sequelize.STRING,
        field: 'pc_destination_url'
    },
    mobileDestinationUrl: {
        type: Sequelize.STRING,
        field: 'mobile_destination_url'
    },
    matchType: {
        type: Sequelize.STRING,
        field: 'match_type'
    },
    pause: {
        type: Sequelize.STRING,
        field: 'pause'
    },
    status: {
        type: Sequelize.STRING,
        field: 'status'
    },
    phraseType: {
        type: Sequelize.STRING,
        field: 'phrase_type'
    },
    wmatchprefer: {
        type: Sequelize.STRING,
        field: 'wmatchprefer'
    },
    pcQuality: {
        type: Sequelize.STRING,
        field: 'pc_quality'
    },
    pcReliable: {
        type: Sequelize.STRING,
        field: 'pc_reliable'
    },
    pcReason: {
        type: Sequelize.STRING,
        field: 'pc_reason'
    },
    pcScale: {
        type: Sequelize.STRING,
        field: 'pc_scale'
    },
    mobileQuality: {
        type: Sequelize.STRING,
        field: 'mobile_quality'
    },
    mobileReliable: {
        type: Sequelize.STRING,
        field: 'mobile_reliable'
    },
    mobileReason: {
        type: Sequelize.STRING,
        field: 'mobile_reason'
    },
    mobileScale: {
        type: Sequelize.STRING,
        field: 'mobile_scale'
    },
    tabs: {
        type: Sequelize.STRING,
        field: 'tabs'
    },
    leftPriceGuide: {
        type: Sequelize.STRING,
        field: 'left_price_guide'
    },
    left3PriceGuide: {
        type: Sequelize.STRING,
        field: 'left3_price_guide'
    },
    mPriceGuide: {
        type: Sequelize.STRING,
        field: 'm_price_guide'
    },
    pcEstimatedClickRate: {
        type: Sequelize.STRING,
        field: 'pc_estimated_click_rate'
    },
    pcBusinessRelationship: {
        type: Sequelize.STRING,
        field: 'pc_business_relationship'
    },
    pcLandPageExperience: {
        type: Sequelize.STRING,
        field: 'pc_land_page_experience'
    },
    mobile_estimated_click_rate: {
        type: Sequelize.STRING,
        field: 'mobile_estimated_click_rate'
    },
    mobile_business_relationship: {
        type: Sequelize.STRING,
        field: 'mobile_business_relationship'
    },
    mobile_land_page_experience: {
        type: Sequelize.STRING,
        field: 'mobile_land_page_experience'
    },
}, {
    underscored: true,
    freezeTableName: true
});